Geographic Information Sharing Tool

GIST -  Public Version  -  2006

Revised 2009

---------------------

Developed with support of Harvard Provost Innovation Grant, 2006

Developers:

Bill Hays (www.nearity.com) KML parsing and ingest scripts, GML converter,  database design

Merrick Lex Berman  (www.dbr.nu)  GUI, KML query and download scripts, GoogleMaps display    

---------------------

system requirements:

PHP5  (with-libxml)
mySQL5

GoogleMaps Key (if you want to autoload GoogleMap in the lex_upload_parse.php script, see note 2 below)


--------------------

notes on setup:

1) create a mysql database for the application.  run the statements in GIST_create_tables (in the order shown) to create the tables with foreign keys and cascading dependencies.  run the INSERT statement for the courses table to create a test course.

you must supply your mySQL database connection info ($db_addr", "$db_user", "$db_pass", $db_name) by changing the values in the file "connect.inc":

<?php
$db_addr ='localhost'; 	
$db_user = 'mysql_username'; 
$db_pass = 'password';	
$db_name = 'mysql_database';
?>


2) if you want to autoload GoogleMap showing which points were submitted, you will need to apply for a GoogleMap Key:  http://www.google.com/apis/maps/signup.html

you must provide the exact path to the folder where you want to run the GoogleMap Key when you sign up.  assuming you have obtained your GoogleMap Key and the file lex_upload_parse.php is in the correct directory that you signed up for, just swap YOUR key for the one being used in the following line, after key= , being careful not to overwrite the closing backslash and quote \":

<script src=\"http://maps.google.com/maps?file=api&v=2&key=ABQIAAAAJo8Wt4hE_igzXMXthENh2xSExnSlIY6_J0qfqBYoNVVubgcpXBTtt-Xm8o6eqUt-CJO0-wYLJWG4CQ\" type=\"text/javascript\"></script>

if you just want to remove this entire GoogleMaps feature, then clip out all the lines in the lex_upload_parse.php script, from "<div id=\"map\" style=\"width: 600px; height: 480px\"></div>"  down to but not including "mysql_close($link); "  and also the snippet below the php close line:  "//]]>  </script>"   

the upload will work without the GoogleMap section, but isn't as cool.  

3)  you must create the tables in mySql 5 with the scripts in the file GIST_CREATE_MYSQL before running the GUI.  once the tables exist and you have set up your connection info (as in step 1 above) from the GUI all the tables will be populated based on user submitted info.

4)  to add additional CLASSES or PROJECTS for users to participate in, simply copy the INSERT statement at the end of the GIST_create_tables file, and replace the values with your desired names.  For example, to create a Class called "Lunar Chemistry," with instructor "Chesley Bonestell, III" being taught in the "Spring 2007" period, run this command for the MySQL database where your tables have been created:

INSERT INTO courses (course_id, course_name, course_instructor, course_semester)  VALUES (NULL,'Lunar Chemisty', 'Chesley Bonestell, III', 'Spring 2007');


